DROP TABLE IF EXISTS jms_ods.yl_oms_waybill_deliver_count ;
CREATE EXTERNAL TABLE jms_ods.yl_oms_waybill_deliver_count (
SCANSITECODE          string          comment     ''     ,         --NVARCHAR2(40)
SCANSITENAME          string          comment     ''     ,         --NVARCHAR2(128)
COLLECTQUANTITY          bigint          comment     ''     ,         --NUMBER(10)
SIGNINTRADAYQUANTITY          bigint          comment     ''     ,         --NUMBER(10)
SIGNSECONDDAYQUANTITY          bigint          comment     ''     ,         --NUMBER(10)
SIGNTHIRDLYDAYQUANTITY          bigint          comment     ''     ,         --NUMBER(10)
SIGNTHIRDLYAFTERDAYQUANTITY          bigint          comment     ''     ,         --NUMBER(10)
NOSIGNQUANTITY          bigint          comment     ''     ,         --NUMBER(10)
SIGNABNORMALQUANTITY          double          comment     ''     ,         --NUMBER
CREATE_TIME          timestamp          comment     ''     ,         --DATE
UPDATE_TIME          timestamp          comment     ''     ,         --DATE
INPUTTIME          timestamp          comment     ''              --DATE
)
    COMMENT  '派件时效监控信息合并'
    PARTITIONED BY (dt STRING COMMENT '时间分区')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_ods.db/external/yl_oms_waybill_deliver_count'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );

MSCK REPAIR TABLE jms_ods.yl_oms_waybill_deliver_count;
